/*
 * $Id: CategoryPlanningItemDao.java 3 2011-12-26 07:48:43Z forwardly@hotmail.com $
 * 
 * Copyright (c) 2001-2008 Accentrix Company Limited. All Rights Reserved.
 * 
 * Accentrix Company Limited. ("Accentrix") retains copyright on all text, source
 * and binary code contained in this software and documentation. Accentrix grants
 * Licensee a limited license to use this software, provided that this copyright
 * notice and license appear on all copies of the software. The software source
 * code is provided for reference purposes only and may not be copied, modified 
 * or distributed.
 * 
 * THIS SOFTWARE AND DOCUMENTATION ARE PROVIDED "AS IS," WITHOUT ANY WARRANTY OF
 * ANY KIND UNLESS A SEPARATE WARRANTIES IS PURCHASED FROM ACCENTRIX AND REMAINS
 * VALID.  ALL EXPRESS OR IMPLIED CONDITIONS, REPRESENTATIONS AND WARRANTIES,
 * INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR
 * PURPOSE OR NON-INFRINGEMENT, ARE HEREBY EXCLUDED. ACCENTRIX SHALL NOT BE LIABLE
 * FOR ANY DAMAGES SUFFERED BY LICENSEE AS A RESULT OF USING OR MODIFYING THE
 * SOFTWARE OR ITS DERIVATIVES.
 * 
 * IN NO EVENT WILL ACCENTRIX BE LIABLE FOR ANY LOST REVENUE, PROFIT OR DATA, OR
 * FOR DIRECT, INDIRECT, SPECIAL, CONSEQUENTIAL, INCIDENTAL OR PUNITIVE DAMAGES,
 * HOWEVER CAUSED AND REGARDLESS OF THE THEORY OF LIABILITY, ARISING OUT OF THE
 * USE OF OR INABILITY TO USE SOFTWARE, EVEN IF ACCENTRIX HAS BEEN ADVISED OF THE
 * POSSIBILITY OF SUCH DAMAGES.
 */
package com.lightsaber.trade.as.dao.planning;

import java.util.List;

import org.hibernate.Query;
import org.springframework.stereotype.Component;

import com.lightsaber.trade.as.entity.category.CategoryLeaf;
import com.lightsaber.trade.as.entity.planning.CategoryPlanningItem;
import com.lightsaber.trade.as.entity.planning.Level1Planning;
import com.lightsaber.trade.core.dao.BaseDao;

@Component
public class CategoryPlanningItemDao extends BaseDao<CategoryPlanningItem, String> {

    public CategoryPlanningItem findByPlanAndLeafAndYear(final Level1Planning level1Planning,
            final CategoryLeaf categoryLeaf, final Integer planYear) {

        eq("level1Planning", level1Planning);
        eq("categoryLeaf", categoryLeaf);
        eq("planYear", planYear);

        return unique();
    }

    public boolean hasNotZeroByCategoryLeaf(final CategoryLeaf categoryLeaf) {

        String hql = "select citem from CategoryPlanningItem citem "
                + "where citem.categoryLeaf.id=:categoryLeafId "
                + "and ((citem.plannedPlaces is not null and citem.plannedPlaces<> 0) "
                + "or (citem.planedTrainingHours is not null and citem.planedTrainingHours<> 0) "
                + "or (citem.actualEnrolment is not null and citem.actualEnrolment<> 0)) ";

        Query q = this.createQuery(hql);
        q.setParameter("categoryLeafId", categoryLeaf.getId());

        List cnt = q.list();

        if (cnt.isEmpty()) {
            return false;
        } else {
            return true;
        }
    }
}
